Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SUBSCRIPTIONS

`ALL_SUBSCRIPTIONS` describes the subscriptions accessible to the current user. This view is intended for use by Change Data Capture subscribers.

Related Views

- `DBA_SUBSCRIPTIONS` describes all subscriptions in the database.

- `USER_SUBSCRIPTIONS` describes the subscriptions owned by the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`HANDLE` | `NUMBER` | `NOT NULL` | Subscription handler
`SET_NAME` | `VARCHAR2(30)` | `NOT NULL` | Change set name
`USERNAME` | `VARCHAR2(30)` | `NOT NULL` | User name of the subscriber
`CREATED` | `DATE` | `NOT NULL` | Subscription creation date
`STATUS` | `VARCHAR2(1)` | `NOT NULL` | `N` indicates not yet active, `A` indicates is currently active
`EARLIEST_SCN` | `NUMBER` | `NOT NULL` | Subscription window low boundary
`LATEST_SCN` | `NUMBER` | `NOT NULL` | Subscription window high boundary
`DESCRIPTION` | `VARCHAR2(255)` |  | Comment field for the subscriber
`LAST_PURGED` | `DATE` |  | Last time the subscriber called the `PURGE_WINDOW` for this subscription
`LAST_EXTENDED` | `DATE` |  | Last time the subscriber called the `EXTEND_WINDOW` for this subscription
`SUBSCRIPTION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the subscription

See Also: "DBA_SUBSCRIPTIONS" "USER_SUBSCRIPTIONS"